Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
SID | NUMBER(38) | No | null | 1 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
NONINDIV_NAME | NUMBER(38) | Yes | null | 3 | null | NO | NO | NO |
NONINDIV_TYPE | VARCHAR2(100) | Yes | null | 4 | null | NO | NO | NO |
NONINDIV_SUBTYPE | VARCHAR2(100) | Yes | null | 5 | null | NO | NO | NO |
TIMES_SUBJECT | NUMBER | Yes | null | 6 | null | NO | NO | NO |
INVOLVEMENT_COUNT | NUMBER | Yes | null | 7 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 12-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_CUBE_PARTIC_NONINDIV |
TEXT_LENGTH | 1413 |
TEXT | SELECT DISTINCT I.SID, I.OBJ, N.SID AS NONINDIV_NAME, NT.DISPLAY AS NONINDIV_TYPE, NST.DISPLAY AS NONINDIV_SUBTYPE, NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT, NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT FROM MV_PARTIC_NONINDIV I LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ AND N.IS_CURRENT = 'Y' LEFT JOIN MV_PARTIC_NONINDIV_TYPE NT ON NT.SID = I.NONINDIV_TYPE LEFT JOIN MV_PARTIC_NONINDIV_SUBTYPE NST ON NST.SID = I.NONINDIV_SUBTYPE LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) SUBJECT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'SUBJECT' ) GROUP BY PARTICIPANT ) T ON I.OBJ = T.PARTICIPANT LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) INVOLVEMENT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE 1 = 1 GROUP BY PARTICIPANT ) INV ON I.OBJ = INV.PARTICIPANT |
TEXT_VC | SELECT DISTINCT I.SID, I.OBJ, N.SID AS NONINDIV_NAME, NT.DISPLAY AS NONINDIV_TYPE, NST.DISPLAY AS NONINDIV_SUBTYPE, NVL(T.SUBJECT_COUNT, 0) AS TIMES_SUBJECT, NVL(INV.INVOLVEMENT_COUNT, 0) AS INVOLVEMENT_COUNT FROM MV_PARTIC_NONINDIV I LEFT JOIN MV_PARTIC_NAME N ON I.OBJ = N.OBJ AND N.IS_CURRENT = 'Y' LEFT JOIN MV_PARTIC_NONINDIV_TYPE NT ON NT.SID = I.NONINDIV_TYPE LEFT JOIN MV_PARTIC_NONINDIV_SUBTYPE NST ON NST.SID = I.NONINDIV_SUBTYPE LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) SUBJECT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE INVOLVEMENT_ROLE IN ( SELECT SID FROM MV_PARTIC_ROLE_TYPE WHERE CODE = 'SUBJECT' ) GROUP BY PARTICIPANT ) T ON I.OBJ = T.PARTICIPANT LEFT JOIN ( SELECT PARTICIPANT, COUNT(1) INVOLVEMENT_COUNT FROM MV_PARTIC_INVOLVEMENT MPI WHERE 1 = 1 GROUP BY PARTICIPANT ) INV ON I.OBJ = INV.PARTICIPANT |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|